package com.wn.mapper;

import com.wn.common.pojo.MaxAndMinLatAndLng;
import com.wn.common.pojo.ScenicSpots;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ScenicSpotsMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Integer cityId);

    int insertSelective(ScenicSpots record);

    ScenicSpots selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(ScenicSpots record);

    int updateByPrimaryKey(ScenicSpots record);

    List<ScenicSpots> getByCityRegionCode(Integer regioncode);//根据城市code查询该地的景区

    void insertTempScenicSpots(@Param("detailId") Integer detailId, @Param("scenicSpotsId") Integer scenicSpotsId);//添加目的地详情和酒店的中间表

    List<ScenicSpots> queryAll();

    //高级检索的方法
    public List<ScenicSpots> superSearch(String superSearchKeyWord);

    //修改状态
    int updateNewsinfo(@Param("id") Integer id,@Param("status") Integer status);

    List<ScenicSpots> getScenicSpotsByLatAndLng(MaxAndMinLatAndLng maxAndMinLatAndLng);

    //根据首页点击景点名查询景点表中的景点
    ScenicSpots getscenicSpotsByName(String scenicSpotsName);
}
